﻿CREATE TABLE [cex].[User]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[SiteId] [int] NULL,
[EmailAddress] [varchar] (255) COLLATE Latin1_General_CI_AS NOT NULL,
[Password] [varchar] (255) COLLATE Latin1_General_CI_AS NOT NULL,
[Salt] [int] NOT NULL,
[FirstName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL,
[LastName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL,
[Department] [varchar] (100) COLLATE Latin1_General_CI_AS NULL,
[CountryId] [int] NOT NULL,
[State] [varchar] (100) COLLATE Latin1_General_CI_AS NULL,
[Comment] [varchar] (2000) COLLATE Latin1_General_CI_AS NULL,
[ThumnailId] [int] NOT NULL,
[Anon] [bit] NOT NULL,
[Relative] [bit] NOT NULL,
[EmailAuthenticated] [bit] NOT NULL,
[Created] [datetime] NOT NULL,
[Deleted] [bit] NOT NULL,
[CID] [timestamp] NOT NULL
) ON [PRIMARY]


